{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Checklist","EGAD_Summary","LabSampleSort"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Checklist","index":0,"n_rows":153,"n_cols":8,"rows_kept":153,"cut":false,"hidden":false,"merged":[[76,1,77,1],[33,2,33,6],[46,1,48,1],[46,2,48,2],[47,3,48,4],[48,5,48,6],[35,3,35,4],[9,3,9,4],[106,3,106,8],[107,3,107,8],[9,5,9,6],[134,2,134,4],[119,2,119,8],[120,2,120,4],[133,2,133,8],[116,3,116,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[97,1,97,2],[113,1,113,4],[108,3,108,4],[109,3,109,4],[14,7,14,8],[15,7,15,8],[137,3,137,4],[135,5,135,6],[136,5,136,6],[137,5,137,6],[137,7,137,8],[121,5,121,6],[122,5,122,6],[123,5,123,6],[135,3,135,4],[136,3,136,4],[110,3,110,4],[110,5,110,6],[111,3,111,4],[111,5,111,6],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[136,7,136,8],[134,5,134,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[99,5,99,6],[66,5,66,6],[84,5,84,6],[47,5,47,6],[46,3,46,6],[84,3,84,4],[49,3,49,4],[50,3,50,4],[143,6,143,7],[114,3,114,4],[115,3,115,4],[51,3,51,4],[52,3,52,4],[66,3,66,4],[111,7,111,8],[121,7,121,8],[120,5,120,8],[108,7,109,8],[110,7,110,8],[108,5,108,6],[109,5,109,6],[122,7,122,8],[123,7,123,8],[135,7,135,8]]}
[]
[null,"Site"]
[null,"Project"]
[null,"Date(s) Sampled or Sampling Event"]
[null,"Reviewed by"]
[null,"Date Reviewed"]
[]
[null,"A.  Data Completeness"]
[null,"Item for Review","Reviewer Comments"]
[null,null,null,"Yes",null,"No"]
[null,"Did report include original lab reports?",null,null,null,"*"]
[null,"Was report paginated?",null,null,null,"*"]
[null,"Were all report pages received?",null,null,null,"*"]
[null,"Did report contain results for all samples and analyses requested on the chain of custody form?",null,null,null,"*"]
[null,"Were required QA/QC results included with lab report?",null,null,null,"*"]
[null,"Was EGAD EDD received?",null,null,null,"*"]
[null,"Were required QA/QC results included on EGAD EDD?",null,null,null,"*"]
[null,"Did reported analyte lists meet project specifications?",null,null,null,"*"]
[null,"Did reporting limits meet project specifications?",null,null,null,"*"]
[null,"Was the laboratory Maine certified for all methods/analytes/matrices performed at the time of sample analysis(if required)?",null,null,null,"*"]
[null,"*For all items checked N- contact chemist, lab or consultant for resolution"]
[null,"B.  Preservation and Technical Holding Times"]
[null,"Item for Review","Reviewer Comments",null,"Yes"]
[null,null,null,null,null,null,"If No, put X in box then click button"]
[null,"Sample cooler within required temperature range at time of receipt at laboratory(if No, enter receipt date and cooler temp in reviewer comments)?",null,null,null,1]
[null,"Samples properly preserved at time of receipt at laboratory?",null,null,null,1]
[null,"Was sample extraction/digestion performed within holding time?",null,null,null,2]
[null,"Was sample analysis performed within analytical holding time?",null,null,null,2]
[null,"(1) Review SAP/QAPP requirements, if unavailable use professional judgment to flag data as estimated “J” or as unusable “R”"]
[null,"(2) Review SAP/QAPP requirements, if unavailable,"]
[null,"     If method HT<sample extraction/digestion/analysis time<2X method HT, then estimate data and flag with “J”"]
[null,"     If sample extraction/digestion/analysis time>2X method HT, flag detections with a “J”, flag non-detects as “UJ” or reject data and flag with “R”"]
[]
[null,"C.  Blanks"]
[null,"Item for Review","Reviewer Comments",null,"Yes",null,"No"]
[null,null,null,"If Yes, put X in box then click button"]
[null,"Were blanks run at the frequency specified by the method or SAP/QAPP?",null,null,null,"*"]
[null,"Were target analytes detected in laboratory method blanks?"]
[null,"Were target analytes detected in trip blanks(if applicable)?  ",null,null,null,null,""]
[null,"Were target analytes detected in equipment blanks (if applicable)?"]
[null,"Were target analytes detected in any other types of blanks included in the laboratory data report?"]
[null,"Was data appropriately qualified for blank contamination?",null,null,null,3]
[null,"*Contact chemist, lab or consultant for resolution"]
[null,"(3)Review SAP/QAPP requirements- if unavailable see Attachment A"]
[]
[null,"D.  Surrogates"]
[null,"Item for Review","Reviewer Comments"]
[null,null,null,"Yes",null,"No"]
[null,null,null,null,null,"If No, put X in box then click button"]
[null,"Did the laboratory report results for surrogates (if required by the analytical method)?",null,null,null,"*"]
[null,"If surrogates required were recoveries within acceptance ranges?"]
[null,"If surrogate recoveries were outside acceptance ranges, did the lab re-analyze to confirm matrix interference?",null,null,null,"*"]
[null,"Was data appropriately qualified for unacceptable surrogate recovery(if required)?",null,null,null,4]
[null,"*Contact chemist, lab or consultant for resolution"]
[null,"(4)Review SAP/QAPP requirements, if unavailable:"]
[null,"    If recovery > higher acceptance range, flag associated detects with “J”"]
[null,"    If lower acceptance range > recovery > 10% (20% for volatiles), flag associated detects with “J” and associated non-detects with “UJ”"]
[null,"    If recovery <10% (20% for volatiles), reject associated data and flag with “R”"]
[]
[]
[]
[]
[]
[]
[null,"E.  Laboratory Control Samples (LCS/LCSD)"]
[null,"Item for Review","Reviewer Comments"]
[null,null,null,"Yes",null,"If No, put X in box then click button"]
[null,"Did the LCS include all spiked compounds as required by SAP/QAPP or method?",null,null,null,"*"]
[null,"Were recoveries within acceptance ranges?",null,null,null,5]
[null,"Was data appropriately qualified for unacceptable LCS recovery?",null,null,null,5]
[null,"Were RPD between LCS and LCSD within acceptance ranges?",null,null,null,6]
[null,"*Contact chemist, lab or consultant for resolution"]
[null,"(5)Review SAP/QAPP requirements, if unavailable:"]
[null,"Organics and wet chem: If recovery > higher acceptance range, flag associated detects with “J”"]
[null," If recovery <lower acceptance range, reject data and flag with “R”"]
[]
[null,"Metals: 40%<Aqueous/Water and Soil/Sediment %R <lower acceptance limit ","Qualify results that are ≥ MDL as estimated low “J”,"]
[null,null,"Qualify non-detects as estimated “UJ” "]
[null,"Upper acceptance limit<Aqueous/Water and Soil/Sediment %R < 150% ","Qualify results that are ≥ MDL as estimated high “J” "]
[null,"%Recovery < 40% ","Qualify all results as unusable “R”"]
[null,"%Recovery > 150% ","Qualify all results as unusable “R” "]
[null,"(6) Review SAP/QAPP requirements, if unavailable use professional judgment to flag data as estimated “J” or as unusable “R”"]
[null,"F.  Matrix Spike Samples (MS/MSD)"]
[null,"Item for Review","Reviewer Comments"]
[null,null,null,"Yes",null,"If No, put X in box then click button"]
[null,"Did the MS (if performed) include all spiked compounds as required by SAP/QAPP or method?",null,null,null,"*"]
[null,"Were recoveries within acceptance ranges (if MS performed)?",null,null,null,7]
[null,"Was data appropriately qualified for unacceptable MS recovery (if MS performed)?",null,null,null,7]
[null,"Were RPD between MS and MSD (if performed) within acceptance ranges?",null,null,null,7]
[null,"*Contact chemist, lab or consultant for resolution"]
[null,"(7) Review SAP/QAPP requirements, if unavailable use professional judgment to flag data as estimated “J” or as unusable “R”"]
[]
[]
[]
[]
[]
[]
[null," G.  Duplicates (Note this also applies for analytes reported by more than one method)"]
[null,"Item for Review","Reviewer Comments"]
[null,null,null,"Yes",null,"If No, put X in box then click button"]
[null,"Were lab duplicate or field duplicate analyses performed (if yes list type in reviewer comments)?"]
[null,"Were RPDs (if applicable) within acceptance ranges?",null,null,null,8]
[null,"(8) Review SAP/QAPP requirements, if unavailable:"]
[]
[null,"Qualification of Organic Analytes in Lab or Field Duplicates "]
[null,"Situation 1: Positive Detects in Both Lab or Field Duplicates"]
[null,null,"Aqueous ≤ 30%","Aqueous > 30%"]
[null,"RPD","Non-aqueous ≤ 50%","Non-aqueous > 50%"]
[null,null,null,"Both Duplicates",null,null,null,"One sample conc. > 2 x SQL SQL < Other sample conc. < 2 x. SQL"]
[null,"Sample Results","Both Duplicates ≥ 2xSQL","Both Duplicates ≥ 2 x SQL",null,"SQL < Both Duplicate samples concs. < 2 x SQL"]
[null,"Detects","No Flag","J",null,"Professional Judgment",null,"Professional Judgment"]
[null,"Non-detects","No Flag","NA",null,"NA",null,"NA"]
[null,"Situation 2: Positive Detect in Only One Lab or Field Duplicate Sample9"]
[null,"Non-Aqueous Lab or Field Duplicate Sample Results"]
[null,"Sample Results","One Sample conc. = ND (or value reported as less than the SQL)          SQL < Other Sample Conc. < 2 x SQL","One Sample conc. = ND (or value reported as less than the SQL) Other Sample Conc. >2x SQL"]
[null,"Detects","Professional Judgment","J"]
[null,"Non-detects","Professional Judgment","UJ"]
[null,"(9) RPDs should not be determined for duplicate pairs in this situation."]
[null,"Qualification of Inorganic Analytes Based on Lab or Field Duplicates – Aqueous Matrices"]
[null,null,"Aqueous Lab or Field Duplicate Sample Results"]
[null,"Sample Results","Both Duplicates ≥ 5 x SQL",null,null,"One or Both Duplicates < 5 x SQL10"]
[null,null,"RPD ≤ 30%","RPD > 30%",null,"Abs. Diff. ≤ 2 x SQL",null,"Abs. Diff. > 2 x SQL"]
[null,"Detects","No Flag","J",null,"No Flag",null,"J"]
[null,"Non-detects","No Flag","UJ",null,"No Flag",null,"UJ"]
[null,"(10) No action is taken when both field duplicate results are positive detects < SQL or are non-detects."]
[]
[]
[]
[]
[]
[]
[null,"Qualification of Inorganic Analytes Based on Lab or Field Duplicates - Non-Aqueous Matrices"]
[]
[null,null,"Non-Aqueous Lab or Field Duplicate Sample Results"]
[null,"Sample Results","Both Duplicates ≥ 5 x SQL",null,null,"One or Both Duplicates < 5 x SQL11"]
[null,null,"RPD ≤ 50%","RPD > 50%",null,"Abs. Diff. ≤ 4 x SQL",null,"Abs. Diff. > 4 x SQL"]
[null,"Detects","No flag","J",null,"No Flag",null,"J"]
[null,"Non-detects","No flag","UJ",null,"No Flag",null,"UJ"]
[]
[null,"(11) No action is taken when both field duplicate results are positive detects < SQL or are non-detects."]
[]
[null,"H.  Data Usability"]
[null,"Item for Review","Reviewer Comments"]
[null,null,null,null,"If Yes, put X in box then click button",null,"If No, put X in box then click button"]
[null,"Is there any reason to suspect carryover?",null,"*"]
[null,"Is there any reason to suspect matrix interference?",null,"*"]
[null,"Do chromatograms (if provided) look reasonable?",null,null,null,"*"]
[null,"Is there a compound detected below quantitation limits that should be noted?"]
[null,"Is there any other reason that the data should be qualified?"]
[null,"Was all (or most) data qualified for a particular method or analyte?",null,"*"]
[null,"Was any data rejected during the above review? ",null,"*"]
[null,"Is data quality sufficient for the intended use of the data?",null,null,null,"*"]
[null,"*Contact chemist, lab or consultant for resolution"]

{"sheet":"EGAD_Summary","index":1,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,4,1,6],[2,4,2,6]]}
["*"]
["*","Site:",{"$f":"Checklist!C2","v":0},"EGAD Site ID #"]
["*","Date Data Validated:",{"$f":"Checklist!A3","v":0},"Data Validated by:",{"$f":"-Checklist!A4","v":0}]
["*"]
["*","EGAD Sample Point ID","DEP Sample ID","Lab Sample ID"]
["*",null,null,null,null,"Item Reviewed","Validation Qualifer Adjustments needed "]
["*",null,null,null,null,"Preservation and Holding Times",{"$f":"IF(OR(Checklist!$G$25=\"X\",Checklist!$G$26=\"X\",Checklist!$G$27=\"X\",Checklist!$G$28=\"X\")=TRUE,\"Yes\",IF(AND(Checklist!$E$6=\"X\",Checklist!$E$7=\"X\",Checklist!$E$27=\"X\",Checklist!$E$28=\"X\")=TRUE,\"No\",\"\"))","v":""}]
["*",null,null,null,null,"Blanks",{"$f":"IF(OR(Checklist!$G$37=\"X\",Checklist!$G$42=\"X\",Checklist!$E$38=\"X\",Checklist!$E$39=\"X\",Checklist!$E$40=\"X\",Checklist!$E$41=\"X\")=TRUE,\"Yes\",IF(AND(Checklist!$E$37=\"X\",Checklist!$E$42=\"X\",Checklist!$G$38=\"X\",Checklist!$G$39=\"X\",Checklist!$G$40=\"X\",Checklist!$G$41=\"X\")=TRUE,\"No\",\"\"))","v":""}]
["*",null,null,null,null,"Surrogates",{"$f":"IF(OR(Checklist!$G$50=\"X\",Checklist!$G$51=\"X\",Checklist!$G$53=\"X\")=TRUE,\"Yes\",IF(AND(Checklist!$E$50=\"X\",Checklist!$E$51=\"X\",Checklist!$E$53=\"X\")=TRUE,\"No\",\"\"))","v":""}]
["*",null,null,null,null,"Lab Control Samples",{"$f":"IF(OR(Checklist!$G$68=\"X\",Checklist!$G$69=\"X\",Checklist!$G$70=\"X\",Checklist!$G$71=\"X\")=TRUE,\"Yes\",IF(AND(OR(Checklist!$E$68=\"X\",Checklist!$E$68=\"X\"),OR(Checklist!$E$69=\"X\",Checklist!$E$69=\"X\"),OR(Checklist!$E$70=\"X\",Checklist!$E$70=\"X\"),OR(Checklist!$E$71=\"X\",Checklist!$E$71=\"X\"))=TRUE,\"No\",\"\"))","v":""}]
["*",null,null,null,null,"Matrix Spike Samples",{"$f":"IF(OR(Checklist!$G$86=\"X\",Checklist!$G$87=\"X\",Checklist!$G$88=\"X\",Checklist!$G$89=\"X\")=TRUE,\"Yes\",\"\")","v":""}]
["*",null,null,null,null,"Duplicates",{"$f":"IF(Checklist!$G$102=\"X\",\"Yes\",IF(OR(Checklist!$E$102=\"X\",Checklist!$E$102=\"X\")=TRUE,\"No\",\"\"))","v":""}]
["*",null,null,null,null,"Data Usability",{"$f":"IF(OR(Checklist!$E$145=\"X\",Checklist!$E$146=\"X\",Checklist!$G$147=\"X\",Checklist!$E$148=\"X\")=TRUE,\"Yes\",IF(AND(Checklist!$G$145=\"X\",Checklist!$G$146=\"X\",Checklist!$E$147=\"X\",Checklist!$G$148=\"X\")=TRUE,\"No\",\"\"))","v":""}]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*"]
["*",null,null,null,null,38]
["*"]
["*","Item Reviewed","Method","Analyte","Flag to be entered into Validation Qualifier field","Reason (enter into Validation Comment field)","Lab Sample IDs affected"]

{"sheet":"LabSampleSort","index":2,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["*"]
["*","EGAD Sample Point ID","DEP Sample ID","Lab Sample ID","Method","Analyte","Flag to be entered into Validation Qualifier field","Reason (enter into Validation Comment field)"]